﻿CREATE VIEW [acms].[UserPostVote_View]
AS 
	SELECT 
		a.Id, 
		a.UserId,
		b.UserName,
		b.FirstName,
		b.LastName,
		a.PostGuid,
		a.Score,
		a.Created,
		a.ConcurencyId
	FROM [UserPostVote] a
		inner join [Users] b on a.UserId = b.Id
	where b.Deleted = 0
;